CREATE TABLE [dbo].[ExpenseItem]
(
[EXPENSE_SEQN] [int] NOT NULL CONSTRAINT [DF_ExpenseItem_EXPENSE_SEQN] DEFAULT ((0)),
[EXPENSE_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpenseItem_EXPENSE_TYPE] DEFAULT (''),
[FUND] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpenseItem_FUND] DEFAULT (''),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpenseItem_CAMPAIGN_CODE] DEFAULT (''),
[APPEAL_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpenseItem_APPEAL_CODE] DEFAULT (''),
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpenseItem_MEETING] DEFAULT (''),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpenseItem_PRODUCT_CODE] DEFAULT (''),
[DESCRIPTION] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExpenseItem_DESCRIPTION] DEFAULT (''),
[EXPENSE_DATE] [datetime] NULL,
[EXPENSE_AMOUNT] [money] NOT NULL CONSTRAINT [DF_ExpenseItem_EXPENSE_AMOUNT] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iExpenseItemAPPEAL_CODE] ON [dbo].[ExpenseItem] ([APPEAL_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpenseItemCAMPAIGN_CODE] ON [dbo].[ExpenseItem] ([CAMPAIGN_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpenseItem6] ON [dbo].[ExpenseItem] ([EXPENSE_DATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpenseItemEXPENSE_SEQN] ON [dbo].[ExpenseItem] ([EXPENSE_SEQN]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpenseItemFUND] ON [dbo].[ExpenseItem] ([FUND]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iExpenseItemMEETING] ON [dbo].[ExpenseItem] ([MEETING]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[ExpenseItem] TO [IMIS]
GRANT SELECT ON  [dbo].[ExpenseItem] TO [IMIS]
GRANT INSERT ON  [dbo].[ExpenseItem] TO [IMIS]
GRANT DELETE ON  [dbo].[ExpenseItem] TO [IMIS]
GRANT UPDATE ON  [dbo].[ExpenseItem] TO [IMIS]
GO